DELETE FROM [testdatabase].[dbo].[AGREEMENT1] WHERE   AGREE_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BANK1] WHERE   BNK_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUP_NAME1] WHERE   BENE_GRP_NM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUPS1] WHERE   BENE_GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_PACKAGE1] WHERE   BENE_PKG_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC1] WHERE   TPC_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC_COMMUNICATION1] WHERE   TPC_INQ_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[GROUPS1] WHERE   GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[PERSON_EVENT1] WHERE   PRSN_EVNT_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CODE_VALUE1] WHERE   CD_VAL_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CLAIM1] WHERE   CLM_ID >= 1 ;
TRUNCATE TABLE testdatabase.cdc.dbo_AGREEMENT1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_BENEFIT_GROUP_NAME1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_BENEFIT_GROUPS1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_BENEFIT_PACKAGE1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_TOPIC1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_TOPIC_COMMUNICATION1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_GROUPS1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_PERSON_EVENT1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CODE_VALUE1_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CLAIM1_CT;
DELETE FROM [testdatabase].[dbo].[CLAIM2] WHERE   CLM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[AGREEMENT2] WHERE   AGREE_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BANK2] WHERE   BNK_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUP_NAME2] WHERE   BENE_GRP_NM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUPS2] WHERE   BENE_GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_PACKAGE2] WHERE   BENE_PKG_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC2] WHERE   TPC_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC_COMMUNICATION2] WHERE   TPC_INQ_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[GROUPS2] WHERE   GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[PERSON_EVENT2] WHERE   PRSN_EVNT_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CODE_VALUE2] WHERE   CD_VAL_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CLAIM2] WHERE   CLM_ID >= 1 ;
TRUNCATE TABLE  testdatabase.cdc.dbo_AGREEMENT2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BANK2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUP_NAME2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUPS2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_PACKAGE2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC_COMMUNICATION2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_GROUPS2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_PERSON_EVENT2_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_CODE_VALUE2_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CLAIM2_CT;
DELETE FROM [testdatabase].[dbo].[CLAIM3] WHERE   CLM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[AGREEMENT3] WHERE   AGREE_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BANK3] WHERE   BNK_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUP_NAME3] WHERE   BENE_GRP_NM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUPS3] WHERE   BENE_GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_PACKAGE3] WHERE   BENE_PKG_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC3] WHERE   TPC_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC_COMMUNICATION3] WHERE   TPC_INQ_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[GROUPS3] WHERE   GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[PERSON_EVENT3] WHERE   PRSN_EVNT_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CODE_VALUE3] WHERE   CD_VAL_ID >= 1 ;
TRUNCATE TABLE  testdatabase.cdc.dbo_AGREEMENT3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BANK3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUP_NAME3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUPS3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_PACKAGE3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC_COMMUNICATION3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_GROUPS3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_PERSON_EVENT3_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_CODE_VALUE3_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CLAIM3_CT;
DELETE FROM [testdatabase].[dbo].[CLAIM4] WHERE   CLM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[AGREEMENT4] WHERE   AGREE_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BANK4] WHERE   BNK_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUP_NAME4] WHERE   BENE_GRP_NM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUPS4] WHERE   BENE_GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_PACKAGE4] WHERE   BENE_PKG_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC4] WHERE   TPC_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC_COMMUNICATION4] WHERE   TPC_INQ_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[GROUPS4] WHERE   GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[PERSON_EVENT4] WHERE   PRSN_EVNT_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CODE_VALUE4] WHERE   CD_VAL_ID >= 1 ;
TRUNCATE TABLE  testdatabase.cdc.dbo_AGREEMENT4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BANK4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUP_NAME4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUPS4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_PACKAGE4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC_COMMUNICATION4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_GROUPS4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_PERSON_EVENT4_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_CODE_VALUE4_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CLAIM4_CT;
DELETE FROM [testdatabase].[dbo].[CLAIM5] WHERE   CLM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[AGREEMENT5] WHERE   AGREE_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BANK5] WHERE   BNK_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUP_NAME5] WHERE   BENE_GRP_NM_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_GROUPS5] WHERE   BENE_GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[BENEFIT_PACKAGE5] WHERE   BENE_PKG_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC5] WHERE   TPC_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[TOPIC_COMMUNICATION5] WHERE   TPC_INQ_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[GROUPS5] WHERE   GRP_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[PERSON_EVENT5] WHERE   PRSN_EVNT_ID >= 1 ;
DELETE FROM [testdatabase].[dbo].[CODE_VALUE5] WHERE   CD_VAL_ID >= 1 ;
TRUNCATE TABLE  testdatabase.cdc.dbo_AGREEMENT5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BANK5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUP_NAME5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_GROUPS5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_BENEFIT_PACKAGE5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_TOPIC_COMMUNICATION5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_GROUPS5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_PERSON_EVENT5_CT;
TRUNCATE TABLE  testdatabase.cdc.dbo_CODE_VALUE5_CT;
TRUNCATE TABLE testdatabase.cdc.dbo_CLAIM5_CT;